SET NAMES utf8mb4;
BEGIN;

-- ################ 用户数据 ################
INSERT INTO `system_user` (`id`, `username`, `real_name`, `emp_no`, `birthday`, `gender`, `email`, `email_digest`, `mobile`, `mobile_digest`, `avatar`, `password`, `salt`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, 'admin', '伊娃', NULL, NULL, 'MALE', NULL, NULL, NULL, NULL, '/avatar/man.png', '5ca1f224ef123998d99d8738e7727253', 'kl38c6', NULL, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################ 角色数据 ################
INSERT INTO `system_role` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, 'admin', '超级管理员', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################ 菜单数据 ################
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, NULL, NULL, '首页', 'SYSTEM', '/index', '系统初始化创建', 52, 0, 1, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (2, NULL, NULL, '系统管理', 'DIR', '', '系统初始化创建', 43, 0, 2, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (3, 2, 1, '用户管理', 'SYSTEM', '/system/user', '系统初始化创建', 26, 0, 1, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (4, 2, 7, '角色管理', 'SYSTEM', '/system/role', '系统初始化创建', 63, 0, 2, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (5, 2, 12, '菜单管理', 'SYSTEM', '/system/menu', '系统初始化创建', 58, 0, 3, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (6, NULL, NULL, '系统运维', 'DIR', '', '系统初始化创建', 56, 0, 3, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (7, 6, 25, '系统配置', 'SYSTEM', '/system/config', '系统初始化创建', 57, 0, 1, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (8, 6, 29, '字典管理', 'SYSTEM', '/system/dict', '系统初始化创建', 42, 0, 2, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (9, 6, NULL, '日志管理', 'DIR', '', '系统初始化创建', 64, 0, 3, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (10, 9, 38, '登录日志', 'SYSTEM', '/system/login-log', '系统初始化创建', 31, 0, 1, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (11, 9, 39, '操作日志', 'SYSTEM', '/system/trace-log', '系统初始化创建', 47, 0, 2, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu` (`id`, `parent_id`, `permission_id`, `name`, `type`, `uri`, `remark`, `icon_id`, `disabled`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (12, NULL, NULL, '组件演示', 'SYSTEM', '/components', '系统初始化创建', 38, 0, 3, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################ 菜单图标 ################
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, '权限', 'iconfont icon-permission', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (2, '设置', 'iconfont icon-settings1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (3, '监测', 'iconfont icon-monitor', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (4, '接口', 'iconfont icon-interface', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (5, '菜单', 'iconfont icon-menu', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (6, '表情', 'iconfont icon-emoji', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (7, '接口', 'iconfont icon-interface2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (8, '监控', 'iconfont icon-maintenance4', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (9, '定时任务', 'iconfont icon-task', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (10, '图标管理', 'iconfont icon-icon', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (11, '老师,教练', 'iconfont icon-teacher', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (12, '时间,预约', 'iconfont icon-yuyue1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (13, '班级', 'iconfont icon-class', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (14, '部门', 'iconfont icon-department', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (15, '合同', 'iconfont icon-contract', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (16, '客户', 'iconfont icon-customer1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (17, '消息', 'iconfont icon-message', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (18, '商品,购物袋', 'iconfont icon-goods', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (19, '成绩', 'iconfont icon-score', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (20, '课程', 'iconfont icon-course1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (21, '班级', 'iconfont icon-course2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (22, '店铺', 'iconfont icon-store', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (23, '地址', 'iconfont icon-address3', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (24, '合同', 'iconfont icon-contract1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (25, '合同', 'iconfont icon-contract2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (26, '用户,角色', 'iconfont icon-role', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (27, '日志,书籍', 'iconfont icon-log1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (28, '老师', 'iconfont icon-teacher1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (29, '店铺', 'iconfont icon-store2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (30, '岗位', 'iconfont icon-position1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (31, '登录日志', 'iconfont icon-login-log', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (32, '岗位', 'iconfont icon-position', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (33, '部门,用户组,分销', 'iconfont icon-user-group', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (34, '学生', 'iconfont icon-student2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (35, '学生', 'iconfont icon-student1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (36, '商品', 'iconfont icon-goods1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (37, '地址', 'iconfont icon-address2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (38, '课程,书籍', 'iconfont icon-course3', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (39, '合同', 'iconfont icon-contract4', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (40, '订单', 'iconfont icon-order', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (41, '店铺', 'iconfont icon-store1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (42, '字典,书籍', 'iconfont icon-dict', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (43, '设置', 'iconfont icon-settings', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (44, '学生', 'iconfont icon-student', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (45, '通知', 'iconfont icon-notice', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (46, '地址', 'iconfont icon-address1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (47, '操作日志', 'iconfont icon-log', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (48, '成绩', 'iconfont icon-score2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (49, '首页', 'iconfont icon-home5', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (50, '首页', 'iconfont icon-home4', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (51, '首页', 'iconfont icon-home3', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (52, '首页', 'iconfont icon-home2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (53, '首页', 'iconfont icon-home1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (54, '首页', 'iconfont icon-home', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (55, '运维,维修', 'iconfont icon-maintenance', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (56, '运维', 'iconfont icon-maintenance1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (57, '运维,维修', 'iconfont icon-maintenance2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (58, '菜单', 'iconfont icon-menu1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (59, '用户,会员', 'iconfont icon-member', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (60, '用户,会员', 'iconfont icon-member1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (61, '用户', 'iconfont icon-user', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (62, '用户管理', 'iconfont icon-user1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (63, '角色', 'iconfont icon-role1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (64, '日志管理,签到管理', 'iconfont icon-log2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (65, '退出全屏', 'iconfont icon-exit-fullscreen2', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (66, '退出全屏', 'iconfont icon-exit-fullscreen1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (67, '退出全屏', 'iconfont icon-exit-fullscreen', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (68, '文件', 'iconfont icon-file', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (69, '文件', 'iconfont icon-file1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (70, 'Word,文档', 'iconfont icon-word', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (71, 'Word,文档', 'iconfont icon-word1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (72, 'PDF,文档', 'iconfont icon-pdf', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (73, 'PDF,文档', 'iconfont icon-pdf1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (74, 'Excel,文档', 'iconfont icon-excel', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_icon` (`id`, `name`, `class_name`, `uri`, `access_type`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (75, 'Excel,文档', 'iconfont icon-excel1', '', 'CLASS', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################# 菜单功能 ################ -- 
-- 用户管理
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, 3, 2, '创建用户', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (2, 3, 3, '删除用户', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (3, 3, 4, '修改用户', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (4, 3, 5, '配置用户角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (5, 3, 6, '重置用户密码', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 角色管理
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (6, 4, 8, '创建角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (7, 4, 9, '删除角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (8, 4, 10, '修改角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (9, 4, 11, '配置权限', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 菜单管理
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (10, 5, 13, '创建菜单', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (11, 5, 14, '删除菜单', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (12, 5, 15, '修改菜单', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (13, 5, 16, '菜单排序', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (14, 5, 17, '菜单功能管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (15, 5, 18, '创建菜单功能', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (16, 5, 19, '删除菜单功能', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (17, 5, 20, '修改菜单功能', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (18, 5, 21, '菜单图标管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (19, 5, 22, '创建菜单图标', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (20, 5, 23, '删除菜单图标', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (21, 5, 24, '修改菜单图标', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 系统配置
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (22, 7, 26, '创建配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (23, 7, 27, '删除配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (24, 7, 28, '修改配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 字典管理
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (25, 8, 30, '新建字典', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (26, 8, 31, '删除字典', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (27, 8, 32, '修改字典', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (28, 8, 33, '管理数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (29, 8, 34, '新增数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (30, 8, 35, '删除数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (31, 8, 36, '修改数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_menu_func` (`id`, `menu_id`, `permission_id`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (32, 8, 37, '数据排序', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################ 系统配置数据 ################
INSERT INTO `system_config` (`id`, `permission_id`, `code`, `name`, `value`, `value_type`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, NULL, 'DEFAULT_USER_GENDER', '默认用户性别', 'MALE', 'TEXT', 'SERVER_AND_CLIENT', '系统自动创建：创建用户时的默认性别，MALE=男，FEMALE=女，UNKNOWN=未知', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_config` (`id`, `permission_id`, `code`, `name`, `value`, `value_type`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (2, NULL, 'DEFAULT_DICT_SCOPE', '默认字典作用域', 'BACK_END', 'TEXT', 'SERVER_AND_CLIENT', '系统自动创建：创建字典时的默认类别', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_config` (`id`, `permission_id`, `code`, `name`, `value`, `value_type`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (3, NULL, 'DEFAULT_MENU_TYPE', '默认菜单类型', 'SYSTEM', 'TEXT', 'SERVER_AND_CLIENT', '系统自动创建：创建菜单时的菜单类型默认值', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_config` (`id`, `permission_id`, `code`, `name`, `value`, `value_type`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (4, NULL, 'DEFAULT_CONFIG_SCOPE', '默认系统配置作用域', 'SERVER_AND_CLIENT', 'TEXT', 'SERVER_AND_CLIENT', '系统自动创建：创建系统配置时的默认系统配置作用域', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################ 字典数据 ################
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, 'GENDERS', '性别', 'BACK_END', '系统自动创建：系统人员的性别', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (2, 'MENU_TYPES', '菜单类型', 'BACK_END', '系统自动创建：SYSTEM系统内菜单；EXTERNAL外部链接；IFRAME为网页嵌入', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (3, 'ICON_TYPES', '图标类型', 'BACK_END', '系统自动创建：图标分为class和网络路径两种', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (4, 'SYSTEM_CONFIG_VALUE_TYPES', '系统配置值类型', 'BACK_END', '系统自动创建：在系统配置中，不同的值类型对应不同的输入方式', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (5, 'CONFIG_SCOPES', '系统配置作用域', 'BACK_END', '系统自动创建：SERVER_AND_CLIENT表示配置将加载到服务端和客户端；ONLY_SERVER表示配置将仅加载到服务端', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (6, 'DICT_SCOPES', '字典作用域', 'BACK_END', '系统自动创建：将字典分类，用于管理多端字典，默认情况下，管理后台初始化客户端配置时仅初始化管理后台的字典数据。', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (7, 'TRACE_LOG_STATUSES', '跟踪日志状态', 'BACK_END', '系统自动创建：0=操作失败，1=操作成功，-1=操作未得到处理', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict` (`id`, `code`, `name`, `scope`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (8, 'TRACE_LOG_EXCEPTION_LEVEL', '跟踪日志异常等级', 'BACK_END', '系统自动创建：0=低;5=中;10=高', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (1, 1, 'MALE', '男', 1, NULL, 0, NULL, 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (2, 1, 'FEMALE', '女', 2, NULL, 0, NULL, 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (3, 2, 'DIR', '目录', 1, NULL, 0, '该类型表示菜单是一个目录', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (4, 2, 'SYSTEM', '系统菜单', 2, NULL, 0, '该类型为系统内置的页面', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (5, 2, 'EXTERNAL', '外部链接', 3, NULL, 0, '该类型将直接跳转到指定的外部链接', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (6, 2, 'IFRAME', 'IFRAME嵌入', 4, NULL, 0, '该类型将外部链接通过IFRAME加载到系统中', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (7, 3, 'CLASS', 'CLASS', 1, NULL, 0, '图标将通过CLASS访问', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (8, 3, 'URI', '网络路径', 2, NULL, 0, '图标将通过img标签访问', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (9, 4, 'TEXT', '文本', 1, NULL, 0, '中短文本，使用单行文本输入', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (10, 4, 'LONG_TEXT', '长文本', 2, NULL, 0, '长文本，使用文本域输入', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (11, 5, 'SERVER_AND_CLIENT', '服务端和客户端', 1, NULL, 0, '系统配置会在前后端工程启动时加载到内存或缓存中', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (12, 5, 'ONLY_SERVER', '仅服务端', 2, NULL, 0, '系统配置仅会在后端工程启动时加载到内存或缓存中', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (13, 6, 'BACK_END', '管理后台', 1, NULL, 0, '该类别用于存放管理后台的所有字典', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (14, 7, '1', '操作成功', 1, NULL, 0, '', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (15, 7, '0', '操作失败', 2, NULL, 0, '', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (16, 7, '-1', '未处理', 3, NULL, 0, '', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (17, 8, '0', '低', 1, NULL, 0, '', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (18, 8, '5', '中', 2, NULL, 0, '', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);
INSERT INTO `system_dict_data` (`id`, `dict_id`, `value`, `label`, `sort`, `config`, `disabled`, `remark`, `created_by`, `created_at`, `updated_at`, `deleted`, `updated_by`) VALUES (19, 8, '10', '高', 3, NULL, 0, '', 1, CURRENT_TIMESTAMP, NULL, 0, NULL);

-- ################ 权限数据 ################
-- 用户权限
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, 'system:user:query', '用户管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, 1, null, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (2, 'system:user:create', '创建用户', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (3, 'system:user:update', '修改用户', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (4, 'system:user:delete', '删除用户', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (5, 'system:user:role:config', '配置用户角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (6, 'system:user:password:reset', '重置用户密码', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 角色权限
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (7, 'system:role:query', '角色管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (8, 'system:role:create', '创建角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (9, 'system:role:update', '修改角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (10, 'system:role:delete', '删除角色', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (11, 'system:role:config', '配置权限', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 菜单
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (12, 'system:menu:query', '菜单管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (13, 'system:menu:create', '创建菜单', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (14, 'system:menu:update', '修改菜单', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (15, 'system:menu:delete', '删除菜单', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (16, 'system:menu:sort', '菜单排序', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 菜单功能
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (17, 'system:menu:func:query', '菜单功能管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (18, 'system:menu:func:create', '新建菜单功能', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (19, 'system:menu:func:delete', '删除菜单功能', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (20, 'system:menu:func:update', '修改菜单功能', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 菜单图标
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (21, 'system:menu:icon:query', '菜单图标管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (22, 'system:menu:icon:create', '创建菜单图标', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (23, 'system:menu:icon:delete', '删除菜单图标', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (24, 'system:menu:icon:update', '修改菜单图标', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 系统配置
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (25, 'system:config:query', '系统配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (26, 'system:config:create', '创建配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (27, 'system:config:delete', '删除配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (28, 'system:config:update', '修改配置', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 系统字典
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (29, 'system:dict:query', '字典管理', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (30, 'system:dict:create', '创建字典', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (31, 'system:dict:delete', '删除字典', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (32, 'system:dict:update', '修改字典', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 字典数据
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (33, 'system:dict:data:query', '管理数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (34, 'system:dict:data:create', '新增数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (35, 'system:dict:data:delete', '删除数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (36, 'system:dict:data:update', '修改数据', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (37, 'system:dict:data:sort', '数据排序', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 登录日志
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (38, 'system:loginLog:query', '登录日志', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
-- 操作日志
INSERT INTO `system_permission` (`id`, `code`, `name`, `remark`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (39, 'system:traceLog:query', '操作日志', '系统初始化创建', 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

-- ################ 用户与角色关联 ################
INSERT INTO `system_user_role` (`id`, `user_id`, `role_id`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`) VALUES (1, 1, 1, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);

COMMIT;
